AccountExchGroupRteTable

V8 Message Definiton

METADATA

Attribute	Value
Topic	5120-srse-gateway
MLink Token	ConfigGateway
Product	SRConfigGateway
accessType	SELECT,UPDATE,INSERT,DELETE
MLink Endpoint	MLink-Live

Table Definition

Field	Type	Key	Default Value	Comment
templateName	VARCHAR(32)	PRI	''
clientFirm	VARCHAR(16)	PRI	''
AccntRouteTableList	JSON		'JSON_ARRAY()'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
templateName	1
clientFirm	2

JSON Block (AccntRouteTableList)

Field	Type	Comment
enabled	enum - YesNo
execBrkrCode	enum - execBrkrCode
routeAllocMetric	enum - routeAllocMetric
brkrExDest	enum - brkrExDest	order routing string if any used to force orders use a specific ExDest regardless of the actual exchange destination

SELECT TABLE EXAMPLE QUERY

SELECT *
FROM `SRConfigGateway`.`MsgAccountExchGroupRteTable`
WHERE 
    /* Replace with a VARCHAR(32) */ 
    `templateName` = 'Example_templateName'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

UPDATE TABLE EXAMPLE QUERY

UPDATE `SRConfigGateway`.`MsgAccountExchGroupRteTable` 
SET
    /* Replace with a JSON */
    `AccntRouteTableList` = '{"key": "value"}'
WHERE
    /* Replace with a VARCHAR(32) */ 
    `templateName` = 'Example_templateName'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

INSERT TABLE EXAMPLE QUERY

INSERT INTO `SRConfigGateway`.`MsgAccountExchGroupRteTable`(
    /* Replace with a VARCHAR(32) */ 
    `templateName`,
    /* Replace with a VARCHAR(16) */ 
    `clientFirm`,
    /* Replace with a JSON */
    `AccntRouteTableList`
) 
VALUES(
    'Example_templateName',
    'Example_clientFirm',
    '{"key": "value"}'
);

DELETE TABLE EXAMPLE QUERY

DELETE FROM `SRConfigGateway`.`MsgAccountExchGroupRteTable` 
WHERE
    /* Replace with a VARCHAR(32) */ 
    `templateName` = 'Example_templateName'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

Doc Columns Query

SELECT * FROM SRConfigGateway.doccolumns WHERE TABLE_NAME='AccountExchGroupRteTable' ORDER BY ordinal_position ASC;